{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "af68f867-1fce-42f9-904d-b74b9242faa8",
   "metadata": {},
   "source": [
    "# CSV操作\n",
    "读取text也一样"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "372922c7-6d6a-43c5-951e-4e980fc97958",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "59344575-c2a0-49f5-9c34-846b001f998c",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'2.1.4'"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.__version__"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "acce33e9-f11a-42f6-ba1b-7e8ad87d7cbf",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Key Developments By Date</th>\n",
       "      <th>Key Developments by Type</th>\n",
       "      <th>Company Name(s)</th>\n",
       "      <th>Key Development Headline</th>\n",
       "      <th>Key Development Situation</th>\n",
       "      <th>Key Development Sources</th>\n",
       "      <th>Geographic Locations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-07-26</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Wallbridge Mining Company Limited (TSX:WM)</td>\n",
       "      <td>Wallbridge Mining Company Limited Reports Sign...</td>\n",
       "      <td>Wallbridge Mining Company Limited reported pos...</td>\n",
       "      <td>GlobeNewswire – Canada</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-04-12</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>International Business Machines Corporation (N...</td>\n",
       "      <td>IBM Announces Kyndryl, New Independent Company</td>\n",
       "      <td>IBM announced that Kyndryl will be the name of...</td>\n",
       "      <td>Canada News Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-10-18</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Lazydays Holdings, Inc. (NasdaqCM:GORV)</td>\n",
       "      <td>Lazydays RV Announces Plans to Open Omaha Deal...</td>\n",
       "      <td>Lazydays, The RV Authority, announced that it ...</td>\n",
       "      <td>PR Newswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-05-09</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Good Times Restaurants Inc. (NasdaqCM:GTIM)</td>\n",
       "      <td>Good Times Restaurants Inc. Plans to Open New ...</td>\n",
       "      <td>Good Times Restaurants Inc. announced that it ...</td>\n",
       "      <td>Transcript Collection</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-12-22</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Generation Mining Limited (TSX:GENM)</td>\n",
       "      <td>Generation Mining Limited Agrees to Enter into...</td>\n",
       "      <td>Generation Mining Limited announced that it ha...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-12-02</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Natural Grocers by Vitamin Cottage, Inc. (NYSE...</td>\n",
       "      <td>Natural Grocers Hiring Select Positions for Ne...</td>\n",
       "      <td>Natural Grocers is currently seeking additiona...</td>\n",
       "      <td>PR Newswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-12-12</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Southern Empire Resources Corp. (TSXV:SMP)</td>\n",
       "      <td>Southern Empire Resources Corp. Expands Its Mi...</td>\n",
       "      <td>Southern Empire Resources Corp. announces that...</td>\n",
       "      <td>Other</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-08-15</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Nate's Food Co. (OTCPK:NHMD)</td>\n",
       "      <td>Nate’s Food Co. Expands Bitcoin Mining Operati...</td>\n",
       "      <td>Nate’s Food Co. announced that it has purchase...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2023-06-15</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Rayonier Advanced Materials Inc. (NYSE:RYAM)</td>\n",
       "      <td>Rayonier Advanced Materials Inc. Announces the...</td>\n",
       "      <td>Rayonier Advanced Materials Inc. hosted a cere...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-05-10</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Emerald Holding, Inc. (NYSE:EEX)</td>\n",
       "      <td>Emerald Holding, Inc. Announces New Division D...</td>\n",
       "      <td>Emerald Holding, Inc. announced the creation o...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-03-24</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Clean Seed Capital Group Ltd. (TSXV:CSX)</td>\n",
       "      <td>Clean Seed Capital Group Ltd. to Break Ground ...</td>\n",
       "      <td>Clean Seed Capital Group Ltd. announces the Co...</td>\n",
       "      <td>SEDAR</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Kermode Resources Ltd. (TSXV:KLM)</td>\n",
       "      <td>Kermode Resources Ltd. Receives Work Permit fo...</td>\n",
       "      <td>Kermode Resources Ltd. announced the receipt o...</td>\n",
       "      <td>SEDAR</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2021-07-29</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Rogers Communications Inc. (TSX:RCI.B)</td>\n",
       "      <td>Rogers Communications Continues Canada’s 5G Ne...</td>\n",
       "      <td>Rogers Communications announced that it invest...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-08-10</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Toll Brothers, Inc. (NYSE:TOL)</td>\n",
       "      <td>Toll Brothers Announces Model Homes Now Open a...</td>\n",
       "      <td>Toll Brothers, Inc. announced the opening of 1...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2021-11-16</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>The Wendy's Company (NasdaqGS:WEN)</td>\n",
       "      <td>The Wendy's Company's Opens 1,000th Internatio...</td>\n",
       "      <td>The Wendy's Company announced the opening of i...</td>\n",
       "      <td>PR Newswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Curaleaf Holdings, Inc. (TSX:CURA)</td>\n",
       "      <td>Curaleaf Holdings, Inc. Establishes Curaleaf I...</td>\n",
       "      <td>Curaleaf Holdings, Inc. has simultaneously est...</td>\n",
       "      <td>Canada News Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-03-28</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Delta Apparel, Inc. (NYSEAM:DLA)</td>\n",
       "      <td>Delta Apparel, Inc. Launches New ‘On-Demand’ D...</td>\n",
       "      <td>Delta Apparel, Inc. announced the expansion of...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-05-21</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>KB Home (NYSE:KBH)</td>\n",
       "      <td>KB Home Announces the Grand Opening of Fishers...</td>\n",
       "      <td>KB Home announced the grand opening of Fishers...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2023-05-31</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>PureCycle Technologies, Inc. (NasdaqCM:PCT)</td>\n",
       "      <td>PureCycle Technologies, Inc. Finalizes Financi...</td>\n",
       "      <td>PureCycle Technologies, Inc. announced that it...</td>\n",
       "      <td>Other</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2023-07-17</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Verizon Communications Inc. (NYSE:VZ)</td>\n",
       "      <td>Verizon Continues to Upgrade Daytona's Best Ne...</td>\n",
       "      <td>Verizon has recently made major upgrades to th...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Key Developments By Date Key Developments by Type  \\\n",
       "0                2022-07-26      Business Expansions   \n",
       "1                2021-04-12      Business Expansions   \n",
       "2                2021-10-18      Business Expansions   \n",
       "3                2023-05-09      Business Expansions   \n",
       "4                2021-12-22      Business Expansions   \n",
       "5                2022-12-02      Business Expansions   \n",
       "6                2022-12-12      Business Expansions   \n",
       "7                2022-08-15      Business Expansions   \n",
       "8                2023-06-15      Business Expansions   \n",
       "9                2022-05-10      Business Expansions   \n",
       "10               2021-03-24      Business Expansions   \n",
       "11               2023-12-01      Business Expansions   \n",
       "12               2021-07-29      Business Expansions   \n",
       "13               2022-08-10      Business Expansions   \n",
       "14               2021-11-16      Business Expansions   \n",
       "15               2021-04-07      Business Expansions   \n",
       "16               2022-03-28      Business Expansions   \n",
       "17               2021-05-21      Business Expansions   \n",
       "18               2023-05-31      Business Expansions   \n",
       "19               2023-07-17      Business Expansions   \n",
       "\n",
       "                                      Company Name(s)  \\\n",
       "0          Wallbridge Mining Company Limited (TSX:WM)   \n",
       "1   International Business Machines Corporation (N...   \n",
       "2             Lazydays Holdings, Inc. (NasdaqCM:GORV)   \n",
       "3         Good Times Restaurants Inc. (NasdaqCM:GTIM)   \n",
       "4                Generation Mining Limited (TSX:GENM)   \n",
       "5   Natural Grocers by Vitamin Cottage, Inc. (NYSE...   \n",
       "6          Southern Empire Resources Corp. (TSXV:SMP)   \n",
       "7                        Nate's Food Co. (OTCPK:NHMD)   \n",
       "8        Rayonier Advanced Materials Inc. (NYSE:RYAM)   \n",
       "9                    Emerald Holding, Inc. (NYSE:EEX)   \n",
       "10           Clean Seed Capital Group Ltd. (TSXV:CSX)   \n",
       "11                  Kermode Resources Ltd. (TSXV:KLM)   \n",
       "12             Rogers Communications Inc. (TSX:RCI.B)   \n",
       "13                     Toll Brothers, Inc. (NYSE:TOL)   \n",
       "14                 The Wendy's Company (NasdaqGS:WEN)   \n",
       "15                 Curaleaf Holdings, Inc. (TSX:CURA)   \n",
       "16                   Delta Apparel, Inc. (NYSEAM:DLA)   \n",
       "17                                 KB Home (NYSE:KBH)   \n",
       "18        PureCycle Technologies, Inc. (NasdaqCM:PCT)   \n",
       "19              Verizon Communications Inc. (NYSE:VZ)   \n",
       "\n",
       "                             Key Development Headline  \\\n",
       "0   Wallbridge Mining Company Limited Reports Sign...   \n",
       "1      IBM Announces Kyndryl, New Independent Company   \n",
       "2   Lazydays RV Announces Plans to Open Omaha Deal...   \n",
       "3   Good Times Restaurants Inc. Plans to Open New ...   \n",
       "4   Generation Mining Limited Agrees to Enter into...   \n",
       "5   Natural Grocers Hiring Select Positions for Ne...   \n",
       "6   Southern Empire Resources Corp. Expands Its Mi...   \n",
       "7   Nate’s Food Co. Expands Bitcoin Mining Operati...   \n",
       "8   Rayonier Advanced Materials Inc. Announces the...   \n",
       "9   Emerald Holding, Inc. Announces New Division D...   \n",
       "10  Clean Seed Capital Group Ltd. to Break Ground ...   \n",
       "11  Kermode Resources Ltd. Receives Work Permit fo...   \n",
       "12  Rogers Communications Continues Canada’s 5G Ne...   \n",
       "13  Toll Brothers Announces Model Homes Now Open a...   \n",
       "14  The Wendy's Company's Opens 1,000th Internatio...   \n",
       "15  Curaleaf Holdings, Inc. Establishes Curaleaf I...   \n",
       "16  Delta Apparel, Inc. Launches New ‘On-Demand’ D...   \n",
       "17  KB Home Announces the Grand Opening of Fishers...   \n",
       "18  PureCycle Technologies, Inc. Finalizes Financi...   \n",
       "19  Verizon Continues to Upgrade Daytona's Best Ne...   \n",
       "\n",
       "                            Key Development Situation Key Development Sources  \\\n",
       "0   Wallbridge Mining Company Limited reported pos...  GlobeNewswire – Canada   \n",
       "1   IBM announced that Kyndryl will be the name of...        Canada News Wire   \n",
       "2   Lazydays, The RV Authority, announced that it ...             PR Newswire   \n",
       "3   Good Times Restaurants Inc. announced that it ...   Transcript Collection   \n",
       "4   Generation Mining Limited announced that it ha...           GlobeNewswire   \n",
       "5   Natural Grocers is currently seeking additiona...             PR Newswire   \n",
       "6   Southern Empire Resources Corp. announces that...                   Other   \n",
       "7   Nate’s Food Co. announced that it has purchase...           GlobeNewswire   \n",
       "8   Rayonier Advanced Materials Inc. hosted a cere...           Business Wire   \n",
       "9   Emerald Holding, Inc. announced the creation o...           Business Wire   \n",
       "10  Clean Seed Capital Group Ltd. announces the Co...                   SEDAR   \n",
       "11  Kermode Resources Ltd. announced the receipt o...                   SEDAR   \n",
       "12  Rogers Communications announced that it invest...           GlobeNewswire   \n",
       "13  Toll Brothers, Inc. announced the opening of 1...           GlobeNewswire   \n",
       "14  The Wendy's Company announced the opening of i...             PR Newswire   \n",
       "15  Curaleaf Holdings, Inc. has simultaneously est...        Canada News Wire   \n",
       "16  Delta Apparel, Inc. announced the expansion of...           Business Wire   \n",
       "17  KB Home announced the grand opening of Fishers...           Business Wire   \n",
       "18  PureCycle Technologies, Inc. announced that it...                   Other   \n",
       "19  Verizon has recently made major upgrades to th...           GlobeNewswire   \n",
       "\n",
       "                  Geographic Locations  \n",
       "0   United States and Canada (Primary)  \n",
       "1   United States and Canada (Primary)  \n",
       "2   United States and Canada (Primary)  \n",
       "3   United States and Canada (Primary)  \n",
       "4   United States and Canada (Primary)  \n",
       "5   United States and Canada (Primary)  \n",
       "6   United States and Canada (Primary)  \n",
       "7   United States and Canada (Primary)  \n",
       "8   United States and Canada (Primary)  \n",
       "9   United States and Canada (Primary)  \n",
       "10  United States and Canada (Primary)  \n",
       "11  United States and Canada (Primary)  \n",
       "12  United States and Canada (Primary)  \n",
       "13  United States and Canada (Primary)  \n",
       "14  United States and Canada (Primary)  \n",
       "15  United States and Canada (Primary)  \n",
       "16  United States and Canada (Primary)  \n",
       "17  United States and Canada (Primary)  \n",
       "18  United States and Canada (Primary)  \n",
       "19  United States and Canada (Primary)  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_csv(r\"./out/data.csv\")   # csv 默认是,分隔   可能会用其他符号    sep=\"\\t\"  这个就是设置为 制表符 \\t为分隔符"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "id": "94134c07-5737-45cb-810c-189eaa659f61",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "df = pd.read_csv(r\"./out/data.csv\") "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "id": "033a7779-27a0-4870-a705-4c93426f53d1",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "140"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "id": "b5c0aa59-8a6e-433c-909e-633cf2b5ee96",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(20, 7)"
      ]
     },
     "execution_count": 75,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "id": "8aba1a0f-2c1f-4ed2-a6e5-9a47d3d16e05",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Key Developments By Date</th>\n",
       "      <th>Key Developments by Type</th>\n",
       "      <th>Company Name(s)</th>\n",
       "      <th>Key Development Headline</th>\n",
       "      <th>Key Development Situation</th>\n",
       "      <th>Key Development Sources</th>\n",
       "      <th>Geographic Locations</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-07-26</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Wallbridge Mining Company Limited (TSX:WM)</td>\n",
       "      <td>Wallbridge Mining Company Limited Reports Sign...</td>\n",
       "      <td>Wallbridge Mining Company Limited reported pos...</td>\n",
       "      <td>GlobeNewswire – Canada</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2021-04-12</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>International Business Machines Corporation (N...</td>\n",
       "      <td>IBM Announces Kyndryl, New Independent Company</td>\n",
       "      <td>IBM announced that Kyndryl will be the name of...</td>\n",
       "      <td>Canada News Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2021-10-18</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Lazydays Holdings, Inc. (NasdaqCM:GORV)</td>\n",
       "      <td>Lazydays RV Announces Plans to Open Omaha Deal...</td>\n",
       "      <td>Lazydays, The RV Authority, announced that it ...</td>\n",
       "      <td>PR Newswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2023-05-09</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Good Times Restaurants Inc. (NasdaqCM:GTIM)</td>\n",
       "      <td>Good Times Restaurants Inc. Plans to Open New ...</td>\n",
       "      <td>Good Times Restaurants Inc. announced that it ...</td>\n",
       "      <td>Transcript Collection</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2021-12-22</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Generation Mining Limited (TSX:GENM)</td>\n",
       "      <td>Generation Mining Limited Agrees to Enter into...</td>\n",
       "      <td>Generation Mining Limited announced that it ha...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-12-02</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Natural Grocers by Vitamin Cottage, Inc. (NYSE...</td>\n",
       "      <td>Natural Grocers Hiring Select Positions for Ne...</td>\n",
       "      <td>Natural Grocers is currently seeking additiona...</td>\n",
       "      <td>PR Newswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-12-12</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Southern Empire Resources Corp. (TSXV:SMP)</td>\n",
       "      <td>Southern Empire Resources Corp. Expands Its Mi...</td>\n",
       "      <td>Southern Empire Resources Corp. announces that...</td>\n",
       "      <td>Other</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-08-15</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Nate's Food Co. (OTCPK:NHMD)</td>\n",
       "      <td>Nate’s Food Co. Expands Bitcoin Mining Operati...</td>\n",
       "      <td>Nate’s Food Co. announced that it has purchase...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2023-06-15</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Rayonier Advanced Materials Inc. (NYSE:RYAM)</td>\n",
       "      <td>Rayonier Advanced Materials Inc. Announces the...</td>\n",
       "      <td>Rayonier Advanced Materials Inc. hosted a cere...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-05-10</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Emerald Holding, Inc. (NYSE:EEX)</td>\n",
       "      <td>Emerald Holding, Inc. Announces New Division D...</td>\n",
       "      <td>Emerald Holding, Inc. announced the creation o...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2021-03-24</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Clean Seed Capital Group Ltd. (TSXV:CSX)</td>\n",
       "      <td>Clean Seed Capital Group Ltd. to Break Ground ...</td>\n",
       "      <td>Clean Seed Capital Group Ltd. announces the Co...</td>\n",
       "      <td>SEDAR</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2023-12-01</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Kermode Resources Ltd. (TSXV:KLM)</td>\n",
       "      <td>Kermode Resources Ltd. Receives Work Permit fo...</td>\n",
       "      <td>Kermode Resources Ltd. announced the receipt o...</td>\n",
       "      <td>SEDAR</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2021-07-29</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Rogers Communications Inc. (TSX:RCI.B)</td>\n",
       "      <td>Rogers Communications Continues Canada’s 5G Ne...</td>\n",
       "      <td>Rogers Communications announced that it invest...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-08-10</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Toll Brothers, Inc. (NYSE:TOL)</td>\n",
       "      <td>Toll Brothers Announces Model Homes Now Open a...</td>\n",
       "      <td>Toll Brothers, Inc. announced the opening of 1...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2021-11-16</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>The Wendy's Company (NasdaqGS:WEN)</td>\n",
       "      <td>The Wendy's Company's Opens 1,000th Internatio...</td>\n",
       "      <td>The Wendy's Company announced the opening of i...</td>\n",
       "      <td>PR Newswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2021-04-07</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Curaleaf Holdings, Inc. (TSX:CURA)</td>\n",
       "      <td>Curaleaf Holdings, Inc. Establishes Curaleaf I...</td>\n",
       "      <td>Curaleaf Holdings, Inc. has simultaneously est...</td>\n",
       "      <td>Canada News Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-03-28</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Delta Apparel, Inc. (NYSEAM:DLA)</td>\n",
       "      <td>Delta Apparel, Inc. Launches New ‘On-Demand’ D...</td>\n",
       "      <td>Delta Apparel, Inc. announced the expansion of...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2021-05-21</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>KB Home (NYSE:KBH)</td>\n",
       "      <td>KB Home Announces the Grand Opening of Fishers...</td>\n",
       "      <td>KB Home announced the grand opening of Fishers...</td>\n",
       "      <td>Business Wire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2023-05-31</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>PureCycle Technologies, Inc. (NasdaqCM:PCT)</td>\n",
       "      <td>PureCycle Technologies, Inc. Finalizes Financi...</td>\n",
       "      <td>PureCycle Technologies, Inc. announced that it...</td>\n",
       "      <td>Other</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2023-07-17</td>\n",
       "      <td>Business Expansions</td>\n",
       "      <td>Verizon Communications Inc. (NYSE:VZ)</td>\n",
       "      <td>Verizon Continues to Upgrade Daytona's Best Ne...</td>\n",
       "      <td>Verizon has recently made major upgrades to th...</td>\n",
       "      <td>GlobeNewswire</td>\n",
       "      <td>United States and Canada (Primary)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Key Developments By Date Key Developments by Type  \\\n",
       "0                2022-07-26      Business Expansions   \n",
       "1                2021-04-12      Business Expansions   \n",
       "2                2021-10-18      Business Expansions   \n",
       "3                2023-05-09      Business Expansions   \n",
       "4                2021-12-22      Business Expansions   \n",
       "5                2022-12-02      Business Expansions   \n",
       "6                2022-12-12      Business Expansions   \n",
       "7                2022-08-15      Business Expansions   \n",
       "8                2023-06-15      Business Expansions   \n",
       "9                2022-05-10      Business Expansions   \n",
       "10               2021-03-24      Business Expansions   \n",
       "11               2023-12-01      Business Expansions   \n",
       "12               2021-07-29      Business Expansions   \n",
       "13               2022-08-10      Business Expansions   \n",
       "14               2021-11-16      Business Expansions   \n",
       "15               2021-04-07      Business Expansions   \n",
       "16               2022-03-28      Business Expansions   \n",
       "17               2021-05-21      Business Expansions   \n",
       "18               2023-05-31      Business Expansions   \n",
       "19               2023-07-17      Business Expansions   \n",
       "\n",
       "                                      Company Name(s)  \\\n",
       "0          Wallbridge Mining Company Limited (TSX:WM)   \n",
       "1   International Business Machines Corporation (N...   \n",
       "2             Lazydays Holdings, Inc. (NasdaqCM:GORV)   \n",
       "3         Good Times Restaurants Inc. (NasdaqCM:GTIM)   \n",
       "4                Generation Mining Limited (TSX:GENM)   \n",
       "5   Natural Grocers by Vitamin Cottage, Inc. (NYSE...   \n",
       "6          Southern Empire Resources Corp. (TSXV:SMP)   \n",
       "7                        Nate's Food Co. (OTCPK:NHMD)   \n",
       "8        Rayonier Advanced Materials Inc. (NYSE:RYAM)   \n",
       "9                    Emerald Holding, Inc. (NYSE:EEX)   \n",
       "10           Clean Seed Capital Group Ltd. (TSXV:CSX)   \n",
       "11                  Kermode Resources Ltd. (TSXV:KLM)   \n",
       "12             Rogers Communications Inc. (TSX:RCI.B)   \n",
       "13                     Toll Brothers, Inc. (NYSE:TOL)   \n",
       "14                 The Wendy's Company (NasdaqGS:WEN)   \n",
       "15                 Curaleaf Holdings, Inc. (TSX:CURA)   \n",
       "16                   Delta Apparel, Inc. (NYSEAM:DLA)   \n",
       "17                                 KB Home (NYSE:KBH)   \n",
       "18        PureCycle Technologies, Inc. (NasdaqCM:PCT)   \n",
       "19              Verizon Communications Inc. (NYSE:VZ)   \n",
       "\n",
       "                             Key Development Headline  \\\n",
       "0   Wallbridge Mining Company Limited Reports Sign...   \n",
       "1      IBM Announces Kyndryl, New Independent Company   \n",
       "2   Lazydays RV Announces Plans to Open Omaha Deal...   \n",
       "3   Good Times Restaurants Inc. Plans to Open New ...   \n",
       "4   Generation Mining Limited Agrees to Enter into...   \n",
       "5   Natural Grocers Hiring Select Positions for Ne...   \n",
       "6   Southern Empire Resources Corp. Expands Its Mi...   \n",
       "7   Nate’s Food Co. Expands Bitcoin Mining Operati...   \n",
       "8   Rayonier Advanced Materials Inc. Announces the...   \n",
       "9   Emerald Holding, Inc. Announces New Division D...   \n",
       "10  Clean Seed Capital Group Ltd. to Break Ground ...   \n",
       "11  Kermode Resources Ltd. Receives Work Permit fo...   \n",
       "12  Rogers Communications Continues Canada’s 5G Ne...   \n",
       "13  Toll Brothers Announces Model Homes Now Open a...   \n",
       "14  The Wendy's Company's Opens 1,000th Internatio...   \n",
       "15  Curaleaf Holdings, Inc. Establishes Curaleaf I...   \n",
       "16  Delta Apparel, Inc. Launches New ‘On-Demand’ D...   \n",
       "17  KB Home Announces the Grand Opening of Fishers...   \n",
       "18  PureCycle Technologies, Inc. Finalizes Financi...   \n",
       "19  Verizon Continues to Upgrade Daytona's Best Ne...   \n",
       "\n",
       "                            Key Development Situation Key Development Sources  \\\n",
       "0   Wallbridge Mining Company Limited reported pos...  GlobeNewswire – Canada   \n",
       "1   IBM announced that Kyndryl will be the name of...        Canada News Wire   \n",
       "2   Lazydays, The RV Authority, announced that it ...             PR Newswire   \n",
       "3   Good Times Restaurants Inc. announced that it ...   Transcript Collection   \n",
       "4   Generation Mining Limited announced that it ha...           GlobeNewswire   \n",
       "5   Natural Grocers is currently seeking additiona...             PR Newswire   \n",
       "6   Southern Empire Resources Corp. announces that...                   Other   \n",
       "7   Nate’s Food Co. announced that it has purchase...           GlobeNewswire   \n",
       "8   Rayonier Advanced Materials Inc. hosted a cere...           Business Wire   \n",
       "9   Emerald Holding, Inc. announced the creation o...           Business Wire   \n",
       "10  Clean Seed Capital Group Ltd. announces the Co...                   SEDAR   \n",
       "11  Kermode Resources Ltd. announced the receipt o...                   SEDAR   \n",
       "12  Rogers Communications announced that it invest...           GlobeNewswire   \n",
       "13  Toll Brothers, Inc. announced the opening of 1...           GlobeNewswire   \n",
       "14  The Wendy's Company announced the opening of i...             PR Newswire   \n",
       "15  Curaleaf Holdings, Inc. has simultaneously est...        Canada News Wire   \n",
       "16  Delta Apparel, Inc. announced the expansion of...           Business Wire   \n",
       "17  KB Home announced the grand opening of Fishers...           Business Wire   \n",
       "18  PureCycle Technologies, Inc. announced that it...                   Other   \n",
       "19  Verizon has recently made major upgrades to th...           GlobeNewswire   \n",
       "\n",
       "                  Geographic Locations  \n",
       "0   United States and Canada (Primary)  \n",
       "1   United States and Canada (Primary)  \n",
       "2   United States and Canada (Primary)  \n",
       "3   United States and Canada (Primary)  \n",
       "4   United States and Canada (Primary)  \n",
       "5   United States and Canada (Primary)  \n",
       "6   United States and Canada (Primary)  \n",
       "7   United States and Canada (Primary)  \n",
       "8   United States and Canada (Primary)  \n",
       "9   United States and Canada (Primary)  \n",
       "10  United States and Canada (Primary)  \n",
       "11  United States and Canada (Primary)  \n",
       "12  United States and Canada (Primary)  \n",
       "13  United States and Canada (Primary)  \n",
       "14  United States and Canada (Primary)  \n",
       "15  United States and Canada (Primary)  \n",
       "16  United States and Canada (Primary)  \n",
       "17  United States and Canada (Primary)  \n",
       "18  United States and Canada (Primary)  \n",
       "19  United States and Canada (Primary)  "
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "id": "dd39564c-a8dc-43f3-946c-e8b77382f023",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "df.to_csv(r\"out/data.csv\",index=False)  # index 就是最前面的索引    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a7ac9b3e-59a5-4a92-a715-cfc81f6ecddc",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
